Make mobile friendly apps that collect, update, and search for data. PowerApps can be built in minutes without needing to write any code. Looking for a way to digitalise paper processes? Tired of putting up with the limitations of an out of the box system that just doesn’t fit your needs? Don’t spend time and $$$ on a custom solution, build it yourself with PowerApps.

Do you spend more than 2-3 hours a week doing data entry from internal paper documents to Excel, SharePoint, Teams or other database? Do you need to access Excel files from your phone or tablet? Do you want to create user friendly forms, add in checks & balances and guide users through data entry (in Excel, SharePoint or databases) to increase data quality and minimise human error?

If you can answer “Yes” to ANY of the questions above, then this is the course for you. This course is designed for users wanting to create line of business mobile applications that can be built in minutes without the need of writing code or worrying about all the complexity involved in writing cross-platform applications that support iOS, Android, Windows Phone, Windows and the web.

Nothing really, we’ll tell you everything you need to know about PowerApps. It is recommended that attendees have basic knowledge of:

• Microsoft Excel: PowerApps is designed to make it easier to collect and view data, so if you’re interested in PowerApps you’ll probably have some experience with Excel.
• Basic Excel Formulae: PowerApps is no-code app development, but you can increase its functionality using some custom formulae we like to call “Excel Speak”, so any Excel formula knowledge you have will be a bonus.
• PowerPoint or similar application: PowerApps interface is insert, drag and drop, similar to creating a PowerPoint slide so some experience working with text boxes, inserting images, etc will help you pick things up faster.

You will build a variety of mobile friendly web based apps that connect to Excel, SharePoint and the Dataverse Database. You’ll see how to build an app from template, data and customise it to suit your company brand and requirements.

Module 1 Introduction to PowerApps

• What is Microsoft PowerApps
• The Parts of PowerApps

Module 2 Creating a Canvas App

• Create a Canvas App from data in Excel
• Create a Canvas App from a SharePoint List
• Create a Canvas App from the Dataverse Database

Module 3 Create a Model driven App

• Create a Model driven App from the Dataverse Database

Module 4 Customise a Canvas App

• Customize a gallery in PowerApps
• Customize forms in PowerApps
• Customize a card in PowerApps

Module 5 Create a Canvas App from scratch

• Create a Canvas App from scratch using data from Excel

Module 6 Share an app

• Share an app in PowerApps
• Other things to know
• App sharing and the resources the app uses
• What isn't supported

Module 7 Create a Power Pages External Website Portal App

• Create a Developer Environment and create a Power Pages website
• Add a Web Page
• Add a Dataverse Table as a list component